SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROC [dbo].[usp_DSCacTourNuocNgoaiDangMo]
AS
BEGIN
	SELECT *
	FROM TOUR
	WHERE MA_TOUR LIKE 'NN%' AND TRANG_THAI = 'MO'
	ORDER BY NGAY_DI ASC
END

GO
